﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DbSetQLCNEn" targetNamespace="http://tempuri.org/DbSetQLCNEn.xsd" xmlns:mstns="http://tempuri.org/DbSetQLCNEn.xsd" xmlns="http://tempuri.org/DbSetQLCNEn.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QLCONGNOConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QLCONGNOConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLCONGNOLIBS.Properties.Settings.GlobalReference.Default.QLCONGNOConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Y2015CS51_QLCONGNOConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Y2015CS51_QLCONGNOConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLCONGNOLIBS.Properties.Settings.GlobalReference.Default.Y2015CS51_QLCONGNOConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblUsersTableAdapter" GeneratorDataComponentClassName="tblUsersTableAdapter" Name="tblUsers" UserDataComponentName="tblUsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLCONGNOConnectionString (Settings)" DbObjectName="QLCONGNO.dbo.tblUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblUsers] WHERE (([Id] = @Original_Id) AND ((@IsNull_Fullname = 1 AND [Fullname] IS NULL) OR ([Fullname] = @Original_Fullname)) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_Deleted = 1 AND [Deleted] IS NULL) OR ([Deleted] = @Original_Deleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fullname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Deleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblUsers] ([Id], [Fullname], [Username], [Password], [Avatar], [Email], [Phone], [Address], [IsActive], [Deleted]) VALUES (@Id, @Fullname, @Username, @Password, @Avatar, @Email, @Phone, @Address, @IsActive, @Deleted);
SELECT Id, Fullname, Username, Password, Avatar, Email, Phone, Address, IsActive, Deleted FROM tblUsers WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Avatar" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Avatar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Fullname, Username, Password, Avatar, Email, Phone, Address, IsActive, Deleted FROM dbo.tblUsers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblUsers] SET [Id] = @Id, [Fullname] = @Fullname, [Username] = @Username, [Password] = @Password, [Avatar] = @Avatar, [Email] = @Email, [Phone] = @Phone, [Address] = @Address, [IsActive] = @IsActive, [Deleted] = @Deleted WHERE (([Id] = @Original_Id) AND ((@IsNull_Fullname = 1 AND [Fullname] IS NULL) OR ([Fullname] = @Original_Fullname)) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_Deleted = 1 AND [Deleted] IS NULL) OR ([Deleted] = @Original_Deleted)));
SELECT Id, Fullname, Username, Password, Avatar, Email, Phone, Address, IsActive, Deleted FROM tblUsers WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Avatar" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Avatar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fullname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Deleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Fullname" DataSetColumn="Fullname" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Avatar" DataSetColumn="Avatar" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ICategoryTableAdapter" GeneratorDataComponentClassName="ICategoryTableAdapter" Name="ICategory" UserDataComponentName="ICategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.ICategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ICategory] WHERE (([CategoryID] = @Original_CategoryID) AND ((@IsNull_CategoryName = 1 AND [CategoryName] IS NULL) OR ([CategoryName] = @Original_CategoryName)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ICategory] ([CategoryID], [CategoryName], [isDeleted], [Note]) VALUES (@CategoryID, @CategoryName, @isDeleted, @Note);
SELECT CategoryID, CategoryName, isDeleted, Note FROM ICategory WHERE (CategoryID = @CategoryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CategoryID, CategoryName, isDeleted, Note FROM dbo.ICategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ICategory] SET [CategoryID] = @CategoryID, [CategoryName] = @CategoryName, [isDeleted] = @isDeleted, [Note] = @Note WHERE (([CategoryID] = @Original_CategoryID) AND ((@IsNull_CategoryName = 1 AND [CategoryName] IS NULL) OR ([CategoryName] = @Original_CategoryName)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)));
SELECT CategoryID, CategoryName, isDeleted, Note FROM ICategory WHERE (CategoryID = @CategoryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IZoneTableAdapter" GeneratorDataComponentClassName="IZoneTableAdapter" Name="IZone" UserDataComponentName="IZoneTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IZone" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IZone] WHERE (([ZoneID] = @Original_ZoneID) AND ((@IsNull_ZoneName = 1 AND [ZoneName] IS NULL) OR ([ZoneName] = @Original_ZoneName)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZoneName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IZone] ([ZoneID], [ZoneName], [Note], [isDeleted]) VALUES (@ZoneID, @ZoneName, @Note, @isDeleted);
SELECT ZoneID, ZoneName, Note, isDeleted FROM IZone WHERE (ZoneID = @ZoneID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ZoneID, ZoneName, Note, isDeleted FROM dbo.IZone</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IZone] SET [ZoneID] = @ZoneID, [ZoneName] = @ZoneName, [Note] = @Note, [isDeleted] = @isDeleted WHERE (([ZoneID] = @Original_ZoneID) AND ((@IsNull_ZoneName = 1 AND [ZoneName] IS NULL) OR ([ZoneName] = @Original_ZoneName)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)));
SELECT ZoneID, ZoneName, Note, isDeleted FROM IZone WHERE (ZoneID = @ZoneID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZoneName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ZoneID" DataSetColumn="ZoneID" />
              <Mapping SourceColumn="ZoneName" DataSetColumn="ZoneName" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ICityTableAdapter" GeneratorDataComponentClassName="ICityTableAdapter" Name="ICity" UserDataComponentName="ICityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.ICity" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ICity] WHERE (([CityID] = @Original_CityID) AND ((@IsNull_CityName = 1 AND [CityName] IS NULL) OR ([CityName] = @Original_CityName)) AND ((@IsNull_ZoneID = 1 AND [ZoneID] IS NULL) OR ([ZoneID] = @Original_ZoneID)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZoneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ICity] ([CityID], [CityName], [ZoneID], [isDeleted]) VALUES (@CityID, @CityName, @ZoneID, @isDeleted);
SELECT CityID, CityName, ZoneID, isDeleted FROM ICity WHERE (CityID = @CityID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CityID, CityName, ZoneID, isDeleted FROM dbo.ICity</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ICity] SET [CityID] = @CityID, [CityName] = @CityName, [ZoneID] = @ZoneID, [isDeleted] = @isDeleted WHERE (([CityID] = @Original_CityID) AND ((@IsNull_CityName = 1 AND [CityName] IS NULL) OR ([CityName] = @Original_CityName)) AND ((@IsNull_ZoneID = 1 AND [ZoneID] IS NULL) OR ([ZoneID] = @Original_ZoneID)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)));
SELECT CityID, CityName, ZoneID, isDeleted FROM ICity WHERE (CityID = @CityID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZoneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ZoneID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ZoneID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CityID" DataSetColumn="CityID" />
              <Mapping SourceColumn="CityName" DataSetColumn="CityName" />
              <Mapping SourceColumn="ZoneID" DataSetColumn="ZoneID" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ICustomerTableAdapter" GeneratorDataComponentClassName="ICustomerTableAdapter" Name="ICustomer" UserDataComponentName="ICustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.ICustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ICustomer] WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_CustomerName = 1 AND [CustomerName] IS NULL) OR ([CustomerName] = @Original_CustomerName)) AND ((@IsNull_CompanyName = 1 AND [CompanyName] IS NULL) OR ([CompanyName] = @Original_CompanyName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_PhoneNo = 1 AND [PhoneNo] IS NULL) OR ([PhoneNo] = @Original_PhoneNo)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_CreditLine = 1 AND [CreditLine] IS NULL) OR ([CreditLine] = @Original_CreditLine)) AND ((@IsNull_Due = 1 AND [Due] IS NULL) OR ([Due] = @Original_Due)) AND ((@IsNull_Gov = 1 AND [Gov] IS NULL) OR ([Gov] = @Original_Gov)) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)) AND ((@IsNull_Employee_ID = 1 AND [Employee_ID] IS NULL) OR ([Employee_ID] = @Original_Employee_ID)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_IsDeleted = 1 AND [IsDeleted] IS NULL) OR ([IsDeleted] = @Original_IsDeleted)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_BankAccount = 1 AND [BankAccount] IS NULL) OR ([BankAccount] = @Original_BankAccount)) AND ((@IsNull_BankName = 1 AND [BankName] IS NULL) OR ([BankName] = @Original_BankName)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CustomerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhoneNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PhoneNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditLine" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gov" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ICustomer] ([CustomerID], [CustomerName], [CompanyName], [Address], [PhoneNo], [Email], [CreditLine], [Due], [Gov], [CityID], [Employee_ID], [IsActive], [IsDeleted], [Fax], [BankAccount], [BankName], [Note]) VALUES (@CustomerID, @CustomerName, @CompanyName, @Address, @PhoneNo, @Email, @CreditLine, @Due, @Gov, @CityID, @Employee_ID, @IsActive, @IsDeleted, @Fax, @BankAccount, @BankName, @Note);
SELECT CustomerID, CustomerName, CompanyName, Address, PhoneNo, Email, CreditLine, Due, Gov, CityID, Employee_ID, IsActive, IsDeleted, Fax, BankAccount, BankName, Note FROM ICustomer WHERE (CustomerID = @CustomerID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CustomerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PhoneNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditLine" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CustomerID, CustomerName, CompanyName, Address, PhoneNo, Email, CreditLine, Due, Gov, CityID, Employee_ID, IsActive, IsDeleted, Fax, BankAccount, BankName, Note FROM dbo.ICustomer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ICustomer] SET [CustomerID] = @CustomerID, [CustomerName] = @CustomerName, [CompanyName] = @CompanyName, [Address] = @Address, [PhoneNo] = @PhoneNo, [Email] = @Email, [CreditLine] = @CreditLine, [Due] = @Due, [Gov] = @Gov, [CityID] = @CityID, [Employee_ID] = @Employee_ID, [IsActive] = @IsActive, [IsDeleted] = @IsDeleted, [Fax] = @Fax, [BankAccount] = @BankAccount, [BankName] = @BankName, [Note] = @Note WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_CustomerName = 1 AND [CustomerName] IS NULL) OR ([CustomerName] = @Original_CustomerName)) AND ((@IsNull_CompanyName = 1 AND [CompanyName] IS NULL) OR ([CompanyName] = @Original_CompanyName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_PhoneNo = 1 AND [PhoneNo] IS NULL) OR ([PhoneNo] = @Original_PhoneNo)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_CreditLine = 1 AND [CreditLine] IS NULL) OR ([CreditLine] = @Original_CreditLine)) AND ((@IsNull_Due = 1 AND [Due] IS NULL) OR ([Due] = @Original_Due)) AND ((@IsNull_Gov = 1 AND [Gov] IS NULL) OR ([Gov] = @Original_Gov)) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)) AND ((@IsNull_Employee_ID = 1 AND [Employee_ID] IS NULL) OR ([Employee_ID] = @Original_Employee_ID)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_IsDeleted = 1 AND [IsDeleted] IS NULL) OR ([IsDeleted] = @Original_IsDeleted)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_BankAccount = 1 AND [BankAccount] IS NULL) OR ([BankAccount] = @Original_BankAccount)) AND ((@IsNull_BankName = 1 AND [BankName] IS NULL) OR ([BankName] = @Original_BankName)));
SELECT CustomerID, CustomerName, CompanyName, Address, PhoneNo, Email, CreditLine, Due, Gov, CityID, Employee_ID, IsActive, IsDeleted, Fax, BankAccount, BankName, Note FROM ICustomer WHERE (CustomerID = @CustomerID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CustomerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PhoneNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CreditLine" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Gov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CustomerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhoneNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PhoneNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreditLine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CreditLine" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CreditLine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Due" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Due" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gov" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Gov" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Gov" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Employee_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="CustomerName" DataSetColumn="CustomerName" />
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="PhoneNo" DataSetColumn="PhoneNo" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="CreditLine" DataSetColumn="CreditLine" />
              <Mapping SourceColumn="Due" DataSetColumn="Due" />
              <Mapping SourceColumn="Gov" DataSetColumn="Gov" />
              <Mapping SourceColumn="CityID" DataSetColumn="CityID" />
              <Mapping SourceColumn="Employee_ID" DataSetColumn="Employee_ID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="BankAccount" DataSetColumn="BankAccount" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IDepartmentTableAdapter" GeneratorDataComponentClassName="IDepartmentTableAdapter" Name="IDepartment" UserDataComponentName="IDepartmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IDepartment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IDepartment] WHERE (([DepartmentID] = @Original_DepartmentID) AND ((@IsNull_DepartmentName = 1 AND [DepartmentName] IS NULL) OR ([DepartmentName] = @Original_DepartmentName)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DepartmentName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IDepartment] ([DepartmentID], [DepartmentName], [isDeleted]) VALUES (@DepartmentID, @DepartmentName, @isDeleted);
SELECT DepartmentID, DepartmentName, isDeleted FROM IDepartment WHERE (DepartmentID = @DepartmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DepartmentID, DepartmentName, isDeleted FROM dbo.IDepartment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IDepartment] SET [DepartmentID] = @DepartmentID, [DepartmentName] = @DepartmentName, [isDeleted] = @isDeleted WHERE (([DepartmentID] = @Original_DepartmentID) AND ((@IsNull_DepartmentName = 1 AND [DepartmentName] IS NULL) OR ([DepartmentName] = @Original_DepartmentName)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)));
SELECT DepartmentID, DepartmentName, isDeleted FROM IDepartment WHERE (DepartmentID = @DepartmentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DepartmentName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
              <Mapping SourceColumn="DepartmentName" DataSetColumn="DepartmentName" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IDetail_ReturnTableAdapter" GeneratorDataComponentClassName="IDetail_ReturnTableAdapter" Name="IDetail_Return" UserDataComponentName="IDetail_ReturnTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IDetail_Return" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IDetail_Return] WHERE (([ReturnID] = @Original_ReturnID) AND ([InvoceID] = @Original_InvoceID) AND ((@IsNull_Quantity_return = 1 AND [Quantity_return] IS NULL) OR ([Quantity_return] = @Original_Quantity_return)) AND ([CustomerID] = @Original_CustomerID) AND ([ProductID] = @Original_ProductID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IDetail_Return] ([ReturnID], [InvoceID], [Quantity_return], [CustomerID], [ProductID]) VALUES (@ReturnID, @InvoceID, @Quantity_return, @CustomerID, @ProductID);
SELECT ReturnID, InvoceID, Quantity_return, CustomerID, ProductID FROM IDetail_Return WHERE (CustomerID = @CustomerID) AND (InvoceID = @InvoceID) AND (ProductID = @ProductID) AND (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReturnID, InvoceID, Quantity_return, CustomerID, ProductID FROM dbo.IDetail_Return</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IDetail_Return] SET [ReturnID] = @ReturnID, [InvoceID] = @InvoceID, [Quantity_return] = @Quantity_return, [CustomerID] = @CustomerID, [ProductID] = @ProductID WHERE (([ReturnID] = @Original_ReturnID) AND ([InvoceID] = @Original_InvoceID) AND ((@IsNull_Quantity_return = 1 AND [Quantity_return] IS NULL) OR ([Quantity_return] = @Original_Quantity_return)) AND ([CustomerID] = @Original_CustomerID) AND ([ProductID] = @Original_ProductID));
SELECT ReturnID, InvoceID, Quantity_return, CustomerID, ProductID FROM IDetail_Return WHERE (CustomerID = @CustomerID) AND (InvoceID = @InvoceID) AND (ProductID = @ProductID) AND (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity_return" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity_return" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReturnID" DataSetColumn="ReturnID" />
              <Mapping SourceColumn="InvoceID" DataSetColumn="InvoceID" />
              <Mapping SourceColumn="Quantity_return" DataSetColumn="Quantity_return" />
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IEmployeeTableAdapter" GeneratorDataComponentClassName="IEmployeeTableAdapter" Name="IEmployee" UserDataComponentName="IEmployeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IEmployee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IEmployee] WHERE (([Employee_ID] = @Original_Employee_ID) AND ((@IsNull_EmployeeName = 1 AND [EmployeeName] IS NULL) OR ([EmployeeName] = @Original_EmployeeName)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_avartar = 1 AND [avartar] IS NULL) OR ([avartar] = @Original_avartar)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_IsDeleted = 1 AND [IsDeleted] IS NULL) OR ([IsDeleted] = @Original_IsDeleted)) AND ((@IsNull_DepartmentID = 1 AND [DepartmentID] IS NULL) OR ([DepartmentID] = @Original_DepartmentID)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EmployeeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_avartar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_avartar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IEmployee] ([Employee_ID], [EmployeeName], [UserName], [Password], [avartar], [Email], [Phone], [Address], [Role], [IsActive], [IsDeleted], [DepartmentID], [Note]) VALUES (@Employee_ID, @EmployeeName, @UserName, @Password, @avartar, @Email, @Phone, @Address, @Role, @IsActive, @IsDeleted, @DepartmentID, @Note);
SELECT Employee_ID, EmployeeName, UserName, Password, avartar, Email, Phone, Address, Role, IsActive, IsDeleted, DepartmentID, Note FROM IEmployee WHERE (Employee_ID = @Employee_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmployeeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@avartar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Employee_ID, EmployeeName, UserName, Password, avartar, Email, Phone, Address, Role, IsActive, IsDeleted, DepartmentID, Note FROM dbo.IEmployee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IEmployee] SET [Employee_ID] = @Employee_ID, [EmployeeName] = @EmployeeName, [UserName] = @UserName, [Password] = @Password, [avartar] = @avartar, [Email] = @Email, [Phone] = @Phone, [Address] = @Address, [Role] = @Role, [IsActive] = @IsActive, [IsDeleted] = @IsDeleted, [DepartmentID] = @DepartmentID, [Note] = @Note WHERE (([Employee_ID] = @Original_Employee_ID) AND ((@IsNull_EmployeeName = 1 AND [EmployeeName] IS NULL) OR ([EmployeeName] = @Original_EmployeeName)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_avartar = 1 AND [avartar] IS NULL) OR ([avartar] = @Original_avartar)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_IsActive = 1 AND [IsActive] IS NULL) OR ([IsActive] = @Original_IsActive)) AND ((@IsNull_IsDeleted = 1 AND [IsDeleted] IS NULL) OR ([IsDeleted] = @Original_IsDeleted)) AND ((@IsNull_DepartmentID = 1 AND [DepartmentID] IS NULL) OR ([DepartmentID] = @Original_DepartmentID)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)));
SELECT Employee_ID, EmployeeName, UserName, Password, avartar, Email, Phone, Address, Role, IsActive, IsDeleted, DepartmentID, Note FROM IEmployee WHERE (Employee_ID = @Employee_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmployeeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@avartar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_Employee_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Employee_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EmployeeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmployeeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_avartar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_avartar" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="avartar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Employee_ID" DataSetColumn="Employee_ID" />
              <Mapping SourceColumn="EmployeeName" DataSetColumn="EmployeeName" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="avartar" DataSetColumn="avartar" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IInvoiceTableAdapter" GeneratorDataComponentClassName="IInvoiceTableAdapter" Name="IInvoice" UserDataComponentName="IInvoiceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IInvoice" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IInvoice] WHERE (([InvoceID] = @Original_InvoceID) AND ((@IsNull_Date_Invoice = 1 AND [Date_Invoice] IS NULL) OR ([Date_Invoice] = @Original_Date_Invoice)) AND ((@p3 = 1 AND [P/O] IS NULL) OR ([P/O] = @p2)) AND ((@IsNull_TotalAmountOfInvoice = 1 AND [TotalAmountOfInvoice] IS NULL) OR ([TotalAmountOfInvoice] = @Original_TotalAmountOfInvoice)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_CustomerID = 1 AND [CustomerID] IS NULL) OR ([CustomerID] = @Original_CustomerID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_Invoice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_Date_Invoice" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalAmountOfInvoice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmountOfInvoice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IInvoice] ([InvoceID], [Date_Invoice], [P/O], [TotalAmountOfInvoice], [isDeleted], [CustomerID]) VALUES (@InvoceID, @Date_Invoice, @p1, @TotalAmountOfInvoice, @isDeleted, @CustomerID);
SELECT InvoceID, Date_Invoice, [P/O], TotalAmountOfInvoice, isDeleted, CustomerID FROM IInvoice WHERE (InvoceID = @InvoceID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Date_Invoice" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmountOfInvoice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT InvoceID, Date_Invoice, [P/O], TotalAmountOfInvoice, isDeleted, CustomerID FROM dbo.IInvoice</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IInvoice] SET [InvoceID] = @InvoceID, [Date_Invoice] = @Date_Invoice, [P/O] = @p1, [TotalAmountOfInvoice] = @TotalAmountOfInvoice, [isDeleted] = @isDeleted, [CustomerID] = @CustomerID WHERE (([InvoceID] = @Original_InvoceID) AND ((@IsNull_Date_Invoice = 1 AND [Date_Invoice] IS NULL) OR ([Date_Invoice] = @Original_Date_Invoice)) AND ((@p3 = 1 AND [P/O] IS NULL) OR ([P/O] = @p2)) AND ((@IsNull_TotalAmountOfInvoice = 1 AND [TotalAmountOfInvoice] IS NULL) OR ([TotalAmountOfInvoice] = @Original_TotalAmountOfInvoice)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_CustomerID = 1 AND [CustomerID] IS NULL) OR ([CustomerID] = @Original_CustomerID)));
SELECT InvoceID, Date_Invoice, [P/O], TotalAmountOfInvoice, isDeleted, CustomerID FROM IInvoice WHERE (InvoceID = @InvoceID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Date_Invoice" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalAmountOfInvoice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_Invoice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_Date_Invoice" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Date_Invoice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="P/O" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalAmountOfInvoice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalAmountOfInvoice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalAmountOfInvoice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="InvoceID" DataSetColumn="InvoceID" />
              <Mapping SourceColumn="Date_Invoice" DataSetColumn="Date_Invoice" />
              <Mapping SourceColumn="P/O" DataSetColumn="P/O" />
              <Mapping SourceColumn="TotalAmountOfInvoice" DataSetColumn="TotalAmountOfInvoice" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ILineItemTableAdapter" GeneratorDataComponentClassName="ILineItemTableAdapter" Name="ILineItem" UserDataComponentName="ILineItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.ILineItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ILineItem] WHERE (([InvoceID] = @Original_InvoceID) AND ((@IsNull_DecreaseValue = 1 AND [DecreaseValue] IS NULL) OR ([DecreaseValue] = @Original_DecreaseValue)) AND ((@IsNull_Promotion_Value = 1 AND [Promotion_Value] IS NULL) OR ([Promotion_Value] = @Original_Promotion_Value)) AND ((@IsNull_QuantityOfProduct = 1 AND [QuantityOfProduct] IS NULL) OR ([QuantityOfProduct] = @Original_QuantityOfProduct)) AND ([ProductID] = @Original_ProductID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DecreaseValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DecreaseValue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Promotion_Value" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Promotion_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuantityOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_QuantityOfProduct" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ILineItem] ([InvoceID], [DecreaseValue], [Promotion_Value], [QuantityOfProduct], [ProductID]) VALUES (@InvoceID, @DecreaseValue, @Promotion_Value, @QuantityOfProduct, @ProductID);
SELECT InvoceID, DecreaseValue, Promotion_Value, QuantityOfProduct, ProductID FROM ILineItem WHERE (InvoceID = @InvoceID) AND (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DecreaseValue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Promotion_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@QuantityOfProduct" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT InvoceID, DecreaseValue, Promotion_Value, QuantityOfProduct, ProductID FROM dbo.ILineItem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ILineItem] SET [InvoceID] = @InvoceID, [DecreaseValue] = @DecreaseValue, [Promotion_Value] = @Promotion_Value, [QuantityOfProduct] = @QuantityOfProduct, [ProductID] = @ProductID WHERE (([InvoceID] = @Original_InvoceID) AND ((@IsNull_DecreaseValue = 1 AND [DecreaseValue] IS NULL) OR ([DecreaseValue] = @Original_DecreaseValue)) AND ((@IsNull_Promotion_Value = 1 AND [Promotion_Value] IS NULL) OR ([Promotion_Value] = @Original_Promotion_Value)) AND ((@IsNull_QuantityOfProduct = 1 AND [QuantityOfProduct] IS NULL) OR ([QuantityOfProduct] = @Original_QuantityOfProduct)) AND ([ProductID] = @Original_ProductID));
SELECT InvoceID, DecreaseValue, Promotion_Value, QuantityOfProduct, ProductID FROM ILineItem WHERE (InvoceID = @InvoceID) AND (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DecreaseValue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Promotion_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@QuantityOfProduct" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DecreaseValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DecreaseValue" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="DecreaseValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Promotion_Value" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Promotion_Value" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Promotion_Value" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuantityOfProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_QuantityOfProduct" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="QuantityOfProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="InvoceID" DataSetColumn="InvoceID" />
              <Mapping SourceColumn="DecreaseValue" DataSetColumn="DecreaseValue" />
              <Mapping SourceColumn="Promotion_Value" DataSetColumn="Promotion_Value" />
              <Mapping SourceColumn="QuantityOfProduct" DataSetColumn="QuantityOfProduct" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IPaid_Receipt_InvoiceTableAdapter" GeneratorDataComponentClassName="IPaid_Receipt_InvoiceTableAdapter" Name="IPaid_Receipt_Invoice" UserDataComponentName="IPaid_Receipt_InvoiceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IPaid_Receipt_Invoice" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IPaid_Receipt_Invoice] WHERE (([InvoceID] = @Original_InvoceID) AND ([ReceiptID] = @Original_ReceiptID) AND ((@IsNull_Cash = 1 AND [Cash] IS NULL) OR ([Cash] = @Original_Cash)) AND ((@IsNull_TTR = 1 AND [TTR] IS NULL) OR ([TTR] = @Original_TTR)) AND ((@IsNull_Receipt_Status = 1 AND [Receipt_Status] IS NULL) OR ([Receipt_Status] = @Original_Receipt_Status)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cash" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TTR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TTR" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Receipt_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Receipt_Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IPaid_Receipt_Invoice] ([InvoceID], [ReceiptID], [Cash], [TTR], [Receipt_Status]) VALUES (@InvoceID, @ReceiptID, @Cash, @TTR, @Receipt_Status);
SELECT InvoceID, ReceiptID, Cash, TTR, Receipt_Status FROM IPaid_Receipt_Invoice WHERE (InvoceID = @InvoceID) AND (ReceiptID = @ReceiptID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cash" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TTR" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Receipt_Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT InvoceID, ReceiptID, Cash, TTR, Receipt_Status FROM dbo.IPaid_Receipt_Invoice</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IPaid_Receipt_Invoice] SET [InvoceID] = @InvoceID, [ReceiptID] = @ReceiptID, [Cash] = @Cash, [TTR] = @TTR, [Receipt_Status] = @Receipt_Status WHERE (([InvoceID] = @Original_InvoceID) AND ([ReceiptID] = @Original_ReceiptID) AND ((@IsNull_Cash = 1 AND [Cash] IS NULL) OR ([Cash] = @Original_Cash)) AND ((@IsNull_TTR = 1 AND [TTR] IS NULL) OR ([TTR] = @Original_TTR)) AND ((@IsNull_Receipt_Status = 1 AND [Receipt_Status] IS NULL) OR ([Receipt_Status] = @Original_Receipt_Status)));
SELECT InvoceID, ReceiptID, Cash, TTR, Receipt_Status FROM IPaid_Receipt_Invoice WHERE (InvoceID = @InvoceID) AND (ReceiptID = @ReceiptID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cash" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TTR" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Receipt_Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InvoceID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InvoceID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cash" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TTR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TTR" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TTR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Receipt_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Receipt_Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Receipt_Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="InvoceID" DataSetColumn="InvoceID" />
              <Mapping SourceColumn="ReceiptID" DataSetColumn="ReceiptID" />
              <Mapping SourceColumn="Cash" DataSetColumn="Cash" />
              <Mapping SourceColumn="TTR" DataSetColumn="TTR" />
              <Mapping SourceColumn="Receipt_Status" DataSetColumn="Receipt_Status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IPrice_returnTableAdapter" GeneratorDataComponentClassName="IPrice_returnTableAdapter" Name="IPrice_return" UserDataComponentName="IPrice_returnTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IPrice_return" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IPrice_return] WHERE (((@IsNull_NumberOfDay = 1 AND [NumberOfDay] IS NULL) OR ([NumberOfDay] = @Original_NumberOfDay)) AND ((@IsNull_Price_level = 1 AND [Price_level] IS NULL) OR ([Price_level] = @Original_Price_level)) AND ([ReturnID] = @Original_ReturnID) AND ([CategoryID] = @Original_CategoryID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price_level" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Price_level" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IPrice_return] ([NumberOfDay], [Price_level], [ReturnID], [CategoryID]) VALUES (@NumberOfDay, @Price_level, @ReturnID, @CategoryID);
SELECT NumberOfDay, Price_level, ReturnID, CategoryID FROM IPrice_return WHERE (CategoryID = @CategoryID) AND (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price_level" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NumberOfDay, Price_level, ReturnID, CategoryID FROM dbo.IPrice_return</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IPrice_return] SET [NumberOfDay] = @NumberOfDay, [Price_level] = @Price_level, [ReturnID] = @ReturnID, [CategoryID] = @CategoryID WHERE (((@IsNull_NumberOfDay = 1 AND [NumberOfDay] IS NULL) OR ([NumberOfDay] = @Original_NumberOfDay)) AND ((@IsNull_Price_level = 1 AND [Price_level] IS NULL) OR ([Price_level] = @Original_Price_level)) AND ([ReturnID] = @Original_ReturnID) AND ([CategoryID] = @Original_CategoryID));
SELECT NumberOfDay, Price_level, ReturnID, CategoryID FROM IPrice_return WHERE (CategoryID = @CategoryID) AND (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price_level" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfDay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price_level" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Price_level" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price_level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NumberOfDay" DataSetColumn="NumberOfDay" />
              <Mapping SourceColumn="Price_level" DataSetColumn="Price_level" />
              <Mapping SourceColumn="ReturnID" DataSetColumn="ReturnID" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IProductTableAdapter" GeneratorDataComponentClassName="IProductTableAdapter" Name="IProduct" UserDataComponentName="IProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IProduct" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IProduct] WHERE (([ProductID] = @Original_ProductID) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Input_Price = 1 AND [Input_Price] IS NULL) OR ([Input_Price] = @Original_Input_Price)) AND ((@IsNull_Unit = 1 AND [Unit] IS NULL) OR ([Unit] = @Original_Unit)) AND ((@IsNull_Origin = 1 AND [Origin] IS NULL) OR ([Origin] = @Original_Origin)) AND ((@IsNull_Sale_Price = 1 AND [Sale_Price] IS NULL) OR ([Sale_Price] = @Original_Sale_Price)) AND ((@IsNull_CategoryID = 1 AND [CategoryID] IS NULL) OR ([CategoryID] = @Original_CategoryID)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Input_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Input_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Origin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Origin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sale_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sale_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IProduct] ([ProductID], [ProductName], [Input_Price], [Unit], [Origin], [Sale_Price], [CategoryID], [isDeleted], [Note]) VALUES (@ProductID, @ProductName, @Input_Price, @Unit, @Origin, @Sale_Price, @CategoryID, @isDeleted, @Note);
SELECT ProductID, ProductName, Input_Price, Unit, Origin, Sale_Price, CategoryID, isDeleted, Note FROM IProduct WHERE (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Input_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Origin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sale_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductID, ProductName, Input_Price, Unit, Origin, Sale_Price, CategoryID, isDeleted, Note FROM dbo.IProduct</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IProduct] SET [ProductID] = @ProductID, [ProductName] = @ProductName, [Input_Price] = @Input_Price, [Unit] = @Unit, [Origin] = @Origin, [Sale_Price] = @Sale_Price, [CategoryID] = @CategoryID, [isDeleted] = @isDeleted, [Note] = @Note WHERE (([ProductID] = @Original_ProductID) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Input_Price = 1 AND [Input_Price] IS NULL) OR ([Input_Price] = @Original_Input_Price)) AND ((@IsNull_Unit = 1 AND [Unit] IS NULL) OR ([Unit] = @Original_Unit)) AND ((@IsNull_Origin = 1 AND [Origin] IS NULL) OR ([Origin] = @Original_Origin)) AND ((@IsNull_Sale_Price = 1 AND [Sale_Price] IS NULL) OR ([Sale_Price] = @Original_Sale_Price)) AND ((@IsNull_CategoryID = 1 AND [CategoryID] IS NULL) OR ([CategoryID] = @Original_CategoryID)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)));
SELECT ProductID, ProductName, Input_Price, Unit, Origin, Sale_Price, CategoryID, isDeleted, Note FROM IProduct WHERE (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Input_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Origin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Sale_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Input_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Input_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Input_Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Unit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Origin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Origin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Origin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sale_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Sale_Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Sale_Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Input_Price" DataSetColumn="Input_Price" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="Origin" DataSetColumn="Origin" />
              <Mapping SourceColumn="Sale_Price" DataSetColumn="Sale_Price" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IReceiptTableAdapter" GeneratorDataComponentClassName="IReceiptTableAdapter" Name="IReceipt" UserDataComponentName="IReceiptTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IReceipt" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IReceipt] WHERE (([ReceiptID] = @Original_ReceiptID) AND ((@IsNull_DateReceipt = 1 AND [DateReceipt] IS NULL) OR ([DateReceipt] = @Original_DateReceipt)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReceipt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_DateReceipt" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IReceipt] ([ReceiptID], [DateReceipt], [isDeleted]) VALUES (@ReceiptID, @DateReceipt, @isDeleted);
SELECT ReceiptID, DateReceipt, isDeleted FROM IReceipt WHERE (ReceiptID = @ReceiptID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@DateReceipt" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReceiptID, DateReceipt, isDeleted FROM dbo.IReceipt</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IReceipt] SET [ReceiptID] = @ReceiptID, [DateReceipt] = @DateReceipt, [isDeleted] = @isDeleted WHERE (([ReceiptID] = @Original_ReceiptID) AND ((@IsNull_DateReceipt = 1 AND [DateReceipt] IS NULL) OR ([DateReceipt] = @Original_DateReceipt)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)));
SELECT ReceiptID, DateReceipt, isDeleted FROM IReceipt WHERE (ReceiptID = @ReceiptID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@DateReceipt" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceiptID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceiptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReceipt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_DateReceipt" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReceipt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReceiptID" DataSetColumn="ReceiptID" />
              <Mapping SourceColumn="DateReceipt" DataSetColumn="DateReceipt" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IReturnTableAdapter" GeneratorDataComponentClassName="IReturnTableAdapter" Name="IReturn" UserDataComponentName="IReturnTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Y2015CS51_QLCONGNOConnectionString (Settings)" DbObjectName="Y2015CS51_QLCONGNO.dbo.IReturn" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IReturn] WHERE (([ReturnID] = @Original_ReturnID) AND ((@IsNull_DateReturn = 1 AND [DateReturn] IS NULL) OR ([DateReturn] = @Original_DateReturn)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReturn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_DateReturn" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IReturn] ([ReturnID], [DateReturn], [isDeleted]) VALUES (@ReturnID, @DateReturn, @isDeleted);
SELECT ReturnID, DateReturn, isDeleted FROM IReturn WHERE (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@DateReturn" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReturnID, DateReturn, isDeleted FROM dbo.IReturn</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IReturn] SET [ReturnID] = @ReturnID, [DateReturn] = @DateReturn, [isDeleted] = @isDeleted WHERE (([ReturnID] = @Original_ReturnID) AND ((@IsNull_DateReturn = 1 AND [DateReturn] IS NULL) OR ([DateReturn] = @Original_DateReturn)) AND ((@IsNull_isDeleted = 1 AND [isDeleted] IS NULL) OR ([isDeleted] = @Original_isDeleted)));
SELECT ReturnID, DateReturn, isDeleted FROM IReturn WHERE (ReturnID = @ReturnID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@DateReturn" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReturnID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReturnID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReturn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_DateReturn" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="DateReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReturnID" DataSetColumn="ReturnID" />
              <Mapping SourceColumn="DateReturn" DataSetColumn="DateReturn" />
              <Mapping SourceColumn="isDeleted" DataSetColumn="isDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DbSetQLCNEn" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DbSetQLCNEn" msprop:Generator_UserDSName="DbSetQLCNEn">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblUsers" msprop:Generator_TableClassName="tblUsersDataTable" msprop:Generator_TableVarName="tabletblUsers" msprop:Generator_RowChangedName="tblUsersRowChanged" msprop:Generator_TablePropName="tblUsers" msprop:Generator_RowDeletingName="tblUsersRowDeleting" msprop:Generator_RowChangingName="tblUsersRowChanging" msprop:Generator_RowEvHandlerName="tblUsersRowChangeEventHandler" msprop:Generator_RowDeletedName="tblUsersRowDeleted" msprop:Generator_RowClassName="tblUsersRow" msprop:Generator_UserTableName="tblUsers" msprop:Generator_RowEvArgName="tblUsersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:string" />
              <xs:element name="Fullname" msprop:Generator_ColumnVarNameInTable="columnFullname" msprop:Generator_ColumnPropNameInRow="Fullname" msprop:Generator_ColumnPropNameInTable="FullnameColumn" msprop:Generator_UserColumnName="Fullname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Avatar" msprop:Generator_ColumnVarNameInTable="columnAvatar" msprop:Generator_ColumnPropNameInRow="Avatar" msprop:Generator_ColumnPropNameInTable="AvatarColumn" msprop:Generator_UserColumnName="Avatar" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ICategory" msprop:Generator_TableClassName="ICategoryDataTable" msprop:Generator_TableVarName="tableICategory" msprop:Generator_TablePropName="ICategory" msprop:Generator_RowDeletingName="ICategoryRowDeleting" msprop:Generator_RowChangingName="ICategoryRowChanging" msprop:Generator_RowEvHandlerName="ICategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="ICategoryRowDeleted" msprop:Generator_UserTableName="ICategory" msprop:Generator_RowChangedName="ICategoryRowChanged" msprop:Generator_RowEvArgName="ICategoryRowChangeEvent" msprop:Generator_RowClassName="ICategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IZone" msprop:Generator_TableClassName="IZoneDataTable" msprop:Generator_TableVarName="tableIZone" msprop:Generator_TablePropName="IZone" msprop:Generator_RowDeletingName="IZoneRowDeleting" msprop:Generator_RowChangingName="IZoneRowChanging" msprop:Generator_RowEvHandlerName="IZoneRowChangeEventHandler" msprop:Generator_RowDeletedName="IZoneRowDeleted" msprop:Generator_UserTableName="IZone" msprop:Generator_RowChangedName="IZoneRowChanged" msprop:Generator_RowEvArgName="IZoneRowChangeEvent" msprop:Generator_RowClassName="IZoneRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ZoneID" msprop:Generator_ColumnVarNameInTable="columnZoneID" msprop:Generator_ColumnPropNameInRow="ZoneID" msprop:Generator_ColumnPropNameInTable="ZoneIDColumn" msprop:Generator_UserColumnName="ZoneID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZoneName" msprop:Generator_ColumnVarNameInTable="columnZoneName" msprop:Generator_ColumnPropNameInRow="ZoneName" msprop:Generator_ColumnPropNameInTable="ZoneNameColumn" msprop:Generator_UserColumnName="ZoneName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ICity" msprop:Generator_TableClassName="ICityDataTable" msprop:Generator_TableVarName="tableICity" msprop:Generator_TablePropName="ICity" msprop:Generator_RowDeletingName="ICityRowDeleting" msprop:Generator_RowChangingName="ICityRowChanging" msprop:Generator_RowEvHandlerName="ICityRowChangeEventHandler" msprop:Generator_RowDeletedName="ICityRowDeleted" msprop:Generator_UserTableName="ICity" msprop:Generator_RowChangedName="ICityRowChanged" msprop:Generator_RowEvArgName="ICityRowChangeEvent" msprop:Generator_RowClassName="ICityRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" msprop:Generator_UserColumnName="CityID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CityName" msprop:Generator_ColumnVarNameInTable="columnCityName" msprop:Generator_ColumnPropNameInRow="CityName" msprop:Generator_ColumnPropNameInTable="CityNameColumn" msprop:Generator_UserColumnName="CityName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZoneID" msprop:Generator_ColumnVarNameInTable="columnZoneID" msprop:Generator_ColumnPropNameInRow="ZoneID" msprop:Generator_ColumnPropNameInTable="ZoneIDColumn" msprop:Generator_UserColumnName="ZoneID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ICustomer" msprop:Generator_TableClassName="ICustomerDataTable" msprop:Generator_TableVarName="tableICustomer" msprop:Generator_TablePropName="ICustomer" msprop:Generator_RowDeletingName="ICustomerRowDeleting" msprop:Generator_RowChangingName="ICustomerRowChanging" msprop:Generator_RowEvHandlerName="ICustomerRowChangeEventHandler" msprop:Generator_RowDeletedName="ICustomerRowDeleted" msprop:Generator_UserTableName="ICustomer" msprop:Generator_RowChangedName="ICustomerRowChanged" msprop:Generator_RowEvArgName="ICustomerRowChangeEvent" msprop:Generator_RowClassName="ICustomerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:string" />
              <xs:element name="CustomerName" msprop:Generator_ColumnVarNameInTable="columnCustomerName" msprop:Generator_ColumnPropNameInRow="CustomerName" msprop:Generator_ColumnPropNameInTable="CustomerNameColumn" msprop:Generator_UserColumnName="CustomerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNo" msprop:Generator_ColumnVarNameInTable="columnPhoneNo" msprop:Generator_ColumnPropNameInRow="PhoneNo" msprop:Generator_ColumnPropNameInTable="PhoneNoColumn" msprop:Generator_UserColumnName="PhoneNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreditLine" msprop:Generator_ColumnVarNameInTable="columnCreditLine" msprop:Generator_ColumnPropNameInRow="CreditLine" msprop:Generator_ColumnPropNameInTable="CreditLineColumn" msprop:Generator_UserColumnName="CreditLine" type="xs:decimal" minOccurs="0" />
              <xs:element name="Due" msprop:Generator_ColumnVarNameInTable="columnDue" msprop:Generator_ColumnPropNameInRow="Due" msprop:Generator_ColumnPropNameInTable="DueColumn" msprop:Generator_UserColumnName="Due" type="xs:int" minOccurs="0" />
              <xs:element name="Gov" msprop:Generator_ColumnVarNameInTable="columnGov" msprop:Generator_ColumnPropNameInRow="Gov" msprop:Generator_ColumnPropNameInTable="GovColumn" msprop:Generator_UserColumnName="Gov" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" msprop:Generator_UserColumnName="CityID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Employee_ID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee_ID" type="xs:string" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankAccount" msprop:Generator_ColumnVarNameInTable="columnBankAccount" msprop:Generator_ColumnPropNameInRow="BankAccount" msprop:Generator_ColumnPropNameInTable="BankAccountColumn" msprop:Generator_UserColumnName="BankAccount" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn" msprop:Generator_UserColumnName="BankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IDepartment" msprop:Generator_TableClassName="IDepartmentDataTable" msprop:Generator_TableVarName="tableIDepartment" msprop:Generator_TablePropName="IDepartment" msprop:Generator_RowDeletingName="IDepartmentRowDeleting" msprop:Generator_RowChangingName="IDepartmentRowChanging" msprop:Generator_RowEvHandlerName="IDepartmentRowChangeEventHandler" msprop:Generator_RowDeletedName="IDepartmentRowDeleted" msprop:Generator_UserTableName="IDepartment" msprop:Generator_RowChangedName="IDepartmentRowChanged" msprop:Generator_RowEvArgName="IDepartmentRowChangeEvent" msprop:Generator_RowClassName="IDepartmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DepartmentID" msprop:Generator_ColumnVarNameInTable="columnDepartmentID" msprop:Generator_ColumnPropNameInRow="DepartmentID" msprop:Generator_ColumnPropNameInTable="DepartmentIDColumn" msprop:Generator_UserColumnName="DepartmentID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DepartmentName" msprop:Generator_ColumnVarNameInTable="columnDepartmentName" msprop:Generator_ColumnPropNameInRow="DepartmentName" msprop:Generator_ColumnPropNameInTable="DepartmentNameColumn" msprop:Generator_UserColumnName="DepartmentName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IDetail_Return" msprop:Generator_TableClassName="IDetail_ReturnDataTable" msprop:Generator_TableVarName="tableIDetail_Return" msprop:Generator_TablePropName="IDetail_Return" msprop:Generator_RowDeletingName="IDetail_ReturnRowDeleting" msprop:Generator_RowChangingName="IDetail_ReturnRowChanging" msprop:Generator_RowEvHandlerName="IDetail_ReturnRowChangeEventHandler" msprop:Generator_RowDeletedName="IDetail_ReturnRowDeleted" msprop:Generator_UserTableName="IDetail_Return" msprop:Generator_RowChangedName="IDetail_ReturnRowChanged" msprop:Generator_RowEvArgName="IDetail_ReturnRowChangeEvent" msprop:Generator_RowClassName="IDetail_ReturnRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReturnID" msprop:Generator_ColumnVarNameInTable="columnReturnID" msprop:Generator_ColumnPropNameInRow="ReturnID" msprop:Generator_ColumnPropNameInTable="ReturnIDColumn" msprop:Generator_UserColumnName="ReturnID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InvoceID" msprop:Generator_ColumnVarNameInTable="columnInvoceID" msprop:Generator_ColumnPropNameInRow="InvoceID" msprop:Generator_ColumnPropNameInTable="InvoceIDColumn" msprop:Generator_UserColumnName="InvoceID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity_return" msprop:Generator_ColumnVarNameInTable="columnQuantity_return" msprop:Generator_ColumnPropNameInRow="Quantity_return" msprop:Generator_ColumnPropNameInTable="Quantity_returnColumn" msprop:Generator_UserColumnName="Quantity_return" type="xs:int" minOccurs="0" />
              <xs:element name="CustomerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:string" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IEmployee" msprop:Generator_TableClassName="IEmployeeDataTable" msprop:Generator_TableVarName="tableIEmployee" msprop:Generator_TablePropName="IEmployee" msprop:Generator_RowDeletingName="IEmployeeRowDeleting" msprop:Generator_RowChangingName="IEmployeeRowChanging" msprop:Generator_RowEvHandlerName="IEmployeeRowChangeEventHandler" msprop:Generator_RowDeletedName="IEmployeeRowDeleted" msprop:Generator_UserTableName="IEmployee" msprop:Generator_RowChangedName="IEmployeeRowChanged" msprop:Generator_RowEvArgName="IEmployeeRowChangeEvent" msprop:Generator_RowClassName="IEmployeeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Employee_ID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEmployee_ID" msprop:Generator_ColumnPropNameInRow="Employee_ID" msprop:Generator_ColumnPropNameInTable="Employee_IDColumn" msprop:Generator_UserColumnName="Employee_ID" type="xs:string" />
              <xs:element name="EmployeeName" msprop:Generator_ColumnVarNameInTable="columnEmployeeName" msprop:Generator_ColumnPropNameInRow="EmployeeName" msprop:Generator_ColumnPropNameInTable="EmployeeNameColumn" msprop:Generator_UserColumnName="EmployeeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="avartar" msprop:Generator_ColumnVarNameInTable="columnavartar" msprop:Generator_ColumnPropNameInRow="avartar" msprop:Generator_ColumnPropNameInTable="avartarColumn" msprop:Generator_UserColumnName="avartar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="DepartmentID" msprop:Generator_ColumnVarNameInTable="columnDepartmentID" msprop:Generator_ColumnPropNameInRow="DepartmentID" msprop:Generator_ColumnPropNameInTable="DepartmentIDColumn" msprop:Generator_UserColumnName="DepartmentID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IInvoice" msprop:Generator_TableClassName="IInvoiceDataTable" msprop:Generator_TableVarName="tableIInvoice" msprop:Generator_TablePropName="IInvoice" msprop:Generator_RowDeletingName="IInvoiceRowDeleting" msprop:Generator_RowChangingName="IInvoiceRowChanging" msprop:Generator_RowEvHandlerName="IInvoiceRowChangeEventHandler" msprop:Generator_RowDeletedName="IInvoiceRowDeleted" msprop:Generator_UserTableName="IInvoice" msprop:Generator_RowChangedName="IInvoiceRowChanged" msprop:Generator_RowEvArgName="IInvoiceRowChangeEvent" msprop:Generator_RowClassName="IInvoiceRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="InvoceID" msprop:Generator_ColumnVarNameInTable="columnInvoceID" msprop:Generator_ColumnPropNameInRow="InvoceID" msprop:Generator_ColumnPropNameInTable="InvoceIDColumn" msprop:Generator_UserColumnName="InvoceID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date_Invoice" msprop:Generator_ColumnVarNameInTable="columnDate_Invoice" msprop:Generator_ColumnPropNameInRow="Date_Invoice" msprop:Generator_ColumnPropNameInTable="Date_InvoiceColumn" msprop:Generator_UserColumnName="Date_Invoice" type="xs:dateTime" minOccurs="0" />
              <xs:element name="P_x002F_O" msprop:Generator_ColumnVarNameInTable="_columnP_O" msprop:Generator_ColumnPropNameInRow="_P_O" msprop:Generator_ColumnPropNameInTable="_P_OColumn" msprop:Generator_UserColumnName="P/O" type="xs:int" minOccurs="0" />
              <xs:element name="TotalAmountOfInvoice" msprop:Generator_ColumnVarNameInTable="columnTotalAmountOfInvoice" msprop:Generator_ColumnPropNameInRow="TotalAmountOfInvoice" msprop:Generator_ColumnPropNameInTable="TotalAmountOfInvoiceColumn" msprop:Generator_UserColumnName="TotalAmountOfInvoice" type="xs:decimal" minOccurs="0" />
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="CustomerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ILineItem" msprop:Generator_TableClassName="ILineItemDataTable" msprop:Generator_TableVarName="tableILineItem" msprop:Generator_TablePropName="ILineItem" msprop:Generator_RowDeletingName="ILineItemRowDeleting" msprop:Generator_RowChangingName="ILineItemRowChanging" msprop:Generator_RowEvHandlerName="ILineItemRowChangeEventHandler" msprop:Generator_RowDeletedName="ILineItemRowDeleted" msprop:Generator_UserTableName="ILineItem" msprop:Generator_RowChangedName="ILineItemRowChanged" msprop:Generator_RowEvArgName="ILineItemRowChangeEvent" msprop:Generator_RowClassName="ILineItemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="InvoceID" msprop:Generator_ColumnVarNameInTable="columnInvoceID" msprop:Generator_ColumnPropNameInRow="InvoceID" msprop:Generator_ColumnPropNameInTable="InvoceIDColumn" msprop:Generator_UserColumnName="InvoceID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DecreaseValue" msprop:Generator_ColumnVarNameInTable="columnDecreaseValue" msprop:Generator_ColumnPropNameInRow="DecreaseValue" msprop:Generator_ColumnPropNameInTable="DecreaseValueColumn" msprop:Generator_UserColumnName="DecreaseValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Promotion_Value" msprop:Generator_ColumnVarNameInTable="columnPromotion_Value" msprop:Generator_ColumnPropNameInRow="Promotion_Value" msprop:Generator_ColumnPropNameInTable="Promotion_ValueColumn" msprop:Generator_UserColumnName="Promotion_Value" type="xs:decimal" minOccurs="0" />
              <xs:element name="QuantityOfProduct" msprop:Generator_ColumnVarNameInTable="columnQuantityOfProduct" msprop:Generator_ColumnPropNameInRow="QuantityOfProduct" msprop:Generator_ColumnPropNameInTable="QuantityOfProductColumn" msprop:Generator_UserColumnName="QuantityOfProduct" type="xs:decimal" minOccurs="0" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IPaid_Receipt_Invoice" msprop:Generator_TableClassName="IPaid_Receipt_InvoiceDataTable" msprop:Generator_TableVarName="tableIPaid_Receipt_Invoice" msprop:Generator_TablePropName="IPaid_Receipt_Invoice" msprop:Generator_RowDeletingName="IPaid_Receipt_InvoiceRowDeleting" msprop:Generator_RowChangingName="IPaid_Receipt_InvoiceRowChanging" msprop:Generator_RowEvHandlerName="IPaid_Receipt_InvoiceRowChangeEventHandler" msprop:Generator_RowDeletedName="IPaid_Receipt_InvoiceRowDeleted" msprop:Generator_UserTableName="IPaid_Receipt_Invoice" msprop:Generator_RowChangedName="IPaid_Receipt_InvoiceRowChanged" msprop:Generator_RowEvArgName="IPaid_Receipt_InvoiceRowChangeEvent" msprop:Generator_RowClassName="IPaid_Receipt_InvoiceRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="InvoceID" msprop:Generator_ColumnVarNameInTable="columnInvoceID" msprop:Generator_ColumnPropNameInRow="InvoceID" msprop:Generator_ColumnPropNameInTable="InvoceIDColumn" msprop:Generator_UserColumnName="InvoceID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReceiptID" msprop:Generator_ColumnVarNameInTable="columnReceiptID" msprop:Generator_ColumnPropNameInRow="ReceiptID" msprop:Generator_ColumnPropNameInTable="ReceiptIDColumn" msprop:Generator_UserColumnName="ReceiptID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cash" msprop:Generator_ColumnVarNameInTable="columnCash" msprop:Generator_ColumnPropNameInRow="Cash" msprop:Generator_ColumnPropNameInTable="CashColumn" msprop:Generator_UserColumnName="Cash" type="xs:decimal" minOccurs="0" />
              <xs:element name="TTR" msprop:Generator_ColumnVarNameInTable="columnTTR" msprop:Generator_ColumnPropNameInRow="TTR" msprop:Generator_ColumnPropNameInTable="TTRColumn" msprop:Generator_UserColumnName="TTR" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_Status" msprop:Generator_ColumnVarNameInTable="columnReceipt_Status" msprop:Generator_ColumnPropNameInRow="Receipt_Status" msprop:Generator_ColumnPropNameInTable="Receipt_StatusColumn" msprop:Generator_UserColumnName="Receipt_Status" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IPrice_return" msprop:Generator_TableClassName="IPrice_returnDataTable" msprop:Generator_TableVarName="tableIPrice_return" msprop:Generator_TablePropName="IPrice_return" msprop:Generator_RowDeletingName="IPrice_returnRowDeleting" msprop:Generator_RowChangingName="IPrice_returnRowChanging" msprop:Generator_RowEvHandlerName="IPrice_returnRowChangeEventHandler" msprop:Generator_RowDeletedName="IPrice_returnRowDeleted" msprop:Generator_UserTableName="IPrice_return" msprop:Generator_RowChangedName="IPrice_returnRowChanged" msprop:Generator_RowEvArgName="IPrice_returnRowChangeEvent" msprop:Generator_RowClassName="IPrice_returnRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NumberOfDay" msprop:Generator_ColumnVarNameInTable="columnNumberOfDay" msprop:Generator_ColumnPropNameInRow="NumberOfDay" msprop:Generator_ColumnPropNameInTable="NumberOfDayColumn" msprop:Generator_UserColumnName="NumberOfDay" type="xs:int" minOccurs="0" />
              <xs:element name="Price_level" msprop:Generator_ColumnVarNameInTable="columnPrice_level" msprop:Generator_ColumnPropNameInRow="Price_level" msprop:Generator_ColumnPropNameInTable="Price_levelColumn" msprop:Generator_UserColumnName="Price_level" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReturnID" msprop:Generator_ColumnVarNameInTable="columnReturnID" msprop:Generator_ColumnPropNameInRow="ReturnID" msprop:Generator_ColumnPropNameInTable="ReturnIDColumn" msprop:Generator_UserColumnName="ReturnID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IProduct" msprop:Generator_TableClassName="IProductDataTable" msprop:Generator_TableVarName="tableIProduct" msprop:Generator_TablePropName="IProduct" msprop:Generator_RowDeletingName="IProductRowDeleting" msprop:Generator_RowChangingName="IProductRowChanging" msprop:Generator_RowEvHandlerName="IProductRowChangeEventHandler" msprop:Generator_RowDeletedName="IProductRowDeleted" msprop:Generator_UserTableName="IProduct" msprop:Generator_RowChangedName="IProductRowChanged" msprop:Generator_RowEvArgName="IProductRowChangeEvent" msprop:Generator_RowClassName="IProductRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Input_Price" msprop:Generator_ColumnVarNameInTable="columnInput_Price" msprop:Generator_ColumnPropNameInRow="Input_Price" msprop:Generator_ColumnPropNameInTable="Input_PriceColumn" msprop:Generator_UserColumnName="Input_Price" type="xs:decimal" minOccurs="0" />
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Origin" msprop:Generator_ColumnVarNameInTable="columnOrigin" msprop:Generator_ColumnPropNameInRow="Origin" msprop:Generator_ColumnPropNameInTable="OriginColumn" msprop:Generator_UserColumnName="Origin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sale_Price" msprop:Generator_ColumnVarNameInTable="columnSale_Price" msprop:Generator_ColumnPropNameInRow="Sale_Price" msprop:Generator_ColumnPropNameInTable="Sale_PriceColumn" msprop:Generator_UserColumnName="Sale_Price" type="xs:decimal" minOccurs="0" />
              <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IReceipt" msprop:Generator_TableClassName="IReceiptDataTable" msprop:Generator_TableVarName="tableIReceipt" msprop:Generator_TablePropName="IReceipt" msprop:Generator_RowDeletingName="IReceiptRowDeleting" msprop:Generator_RowChangingName="IReceiptRowChanging" msprop:Generator_RowEvHandlerName="IReceiptRowChangeEventHandler" msprop:Generator_RowDeletedName="IReceiptRowDeleted" msprop:Generator_UserTableName="IReceipt" msprop:Generator_RowChangedName="IReceiptRowChanged" msprop:Generator_RowEvArgName="IReceiptRowChangeEvent" msprop:Generator_RowClassName="IReceiptRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReceiptID" msprop:Generator_ColumnVarNameInTable="columnReceiptID" msprop:Generator_ColumnPropNameInRow="ReceiptID" msprop:Generator_ColumnPropNameInTable="ReceiptIDColumn" msprop:Generator_UserColumnName="ReceiptID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateReceipt" msprop:Generator_ColumnVarNameInTable="columnDateReceipt" msprop:Generator_ColumnPropNameInRow="DateReceipt" msprop:Generator_ColumnPropNameInTable="DateReceiptColumn" msprop:Generator_UserColumnName="DateReceipt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IReturn" msprop:Generator_TableClassName="IReturnDataTable" msprop:Generator_TableVarName="tableIReturn" msprop:Generator_TablePropName="IReturn" msprop:Generator_RowDeletingName="IReturnRowDeleting" msprop:Generator_RowChangingName="IReturnRowChanging" msprop:Generator_RowEvHandlerName="IReturnRowChangeEventHandler" msprop:Generator_RowDeletedName="IReturnRowDeleted" msprop:Generator_UserTableName="IReturn" msprop:Generator_RowChangedName="IReturnRowChanged" msprop:Generator_RowEvArgName="IReturnRowChangeEvent" msprop:Generator_RowClassName="IReturnRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReturnID" msprop:Generator_ColumnVarNameInTable="columnReturnID" msprop:Generator_ColumnPropNameInRow="ReturnID" msprop:Generator_ColumnPropNameInTable="ReturnIDColumn" msprop:Generator_UserColumnName="ReturnID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateReturn" msprop:Generator_ColumnVarNameInTable="columnDateReturn" msprop:Generator_ColumnPropNameInRow="DateReturn" msprop:Generator_ColumnPropNameInTable="DateReturnColumn" msprop:Generator_UserColumnName="DateReturn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isDeleted" msprop:Generator_ColumnVarNameInTable="columnisDeleted" msprop:Generator_ColumnPropNameInRow="isDeleted" msprop:Generator_ColumnPropNameInTable="isDeletedColumn" msprop:Generator_UserColumnName="isDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblUsers" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="ICategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ICategory" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
    <xs:unique name="IZone_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IZone" />
      <xs:field xpath="mstns:ZoneID" />
    </xs:unique>
    <xs:unique name="ICity_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ICity" />
      <xs:field xpath="mstns:CityID" />
    </xs:unique>
    <xs:unique name="ICustomer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ICustomer" />
      <xs:field xpath="mstns:CustomerID" />
    </xs:unique>
    <xs:unique name="IDepartment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IDepartment" />
      <xs:field xpath="mstns:DepartmentID" />
    </xs:unique>
    <xs:unique name="IDetail_Return_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IDetail_Return" />
      <xs:field xpath="mstns:ReturnID" />
      <xs:field xpath="mstns:InvoceID" />
      <xs:field xpath="mstns:CustomerID" />
      <xs:field xpath="mstns:ProductID" />
    </xs:unique>
    <xs:unique name="IEmployee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IEmployee" />
      <xs:field xpath="mstns:Employee_ID" />
    </xs:unique>
    <xs:unique name="IInvoice_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IInvoice" />
      <xs:field xpath="mstns:InvoceID" />
    </xs:unique>
    <xs:unique name="ILineItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ILineItem" />
      <xs:field xpath="mstns:InvoceID" />
      <xs:field xpath="mstns:ProductID" />
    </xs:unique>
    <xs:unique name="IPaid_Receipt_Invoice_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IPaid_Receipt_Invoice" />
      <xs:field xpath="mstns:InvoceID" />
      <xs:field xpath="mstns:ReceiptID" />
    </xs:unique>
    <xs:unique name="IPrice_return_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IPrice_return" />
      <xs:field xpath="mstns:ReturnID" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
    <xs:unique name="IProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IProduct" />
      <xs:field xpath="mstns:ProductID" />
    </xs:unique>
    <xs:unique name="IReceipt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IReceipt" />
      <xs:field xpath="mstns:ReceiptID" />
    </xs:unique>
    <xs:unique name="IReturn_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IReturn" />
      <xs:field xpath="mstns:ReturnID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ICity_IZone" msdata:parent="IZone" msdata:child="ICity" msdata:parentkey="ZoneID" msdata:childkey="ZoneID" msprop:Generator_UserChildTable="ICity" msprop:Generator_ChildPropName="GetICityRows" msprop:Generator_UserRelationName="FK_ICity_IZone" msprop:Generator_ParentPropName="IZoneRow" msprop:Generator_RelationVarName="relationFK_ICity_IZone" msprop:Generator_UserParentTable="IZone" />
      <msdata:Relationship name="FK_ICustomer_ICity" msdata:parent="ICity" msdata:child="ICustomer" msdata:parentkey="CityID" msdata:childkey="CityID" msprop:Generator_UserChildTable="ICustomer" msprop:Generator_ChildPropName="GetICustomerRows" msprop:Generator_UserRelationName="FK_ICustomer_ICity" msprop:Generator_ParentPropName="ICityRow" msprop:Generator_RelationVarName="relationFK_ICustomer_ICity" msprop:Generator_UserParentTable="ICity" />
      <msdata:Relationship name="FK_ICustomer_IEmployee" msdata:parent="IEmployee" msdata:child="ICustomer" msdata:parentkey="Employee_ID" msdata:childkey="Employee_ID" msprop:Generator_UserChildTable="ICustomer" msprop:Generator_ChildPropName="GetICustomerRows" msprop:Generator_UserRelationName="FK_ICustomer_IEmployee" msprop:Generator_RelationVarName="relationFK_ICustomer_IEmployee" msprop:Generator_UserParentTable="IEmployee" msprop:Generator_ParentPropName="IEmployeeRow" />
      <msdata:Relationship name="FK_IDetail_Return_ICustomer" msdata:parent="ICustomer" msdata:child="IDetail_Return" msdata:parentkey="CustomerID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="IDetail_Return" msprop:Generator_ChildPropName="GetIDetail_ReturnRows" msprop:Generator_UserRelationName="FK_IDetail_Return_ICustomer" msprop:Generator_ParentPropName="ICustomerRow" msprop:Generator_RelationVarName="relationFK_IDetail_Return_ICustomer" msprop:Generator_UserParentTable="ICustomer" />
      <msdata:Relationship name="FK_IDetail_Return_IInvoice" msdata:parent="IInvoice" msdata:child="IDetail_Return" msdata:parentkey="InvoceID" msdata:childkey="InvoceID" msprop:Generator_UserChildTable="IDetail_Return" msprop:Generator_ChildPropName="GetIDetail_ReturnRows" msprop:Generator_UserRelationName="FK_IDetail_Return_IInvoice" msprop:Generator_RelationVarName="relationFK_IDetail_Return_IInvoice" msprop:Generator_UserParentTable="IInvoice" msprop:Generator_ParentPropName="IInvoiceRow" />
      <msdata:Relationship name="FK_IDetail_Return_IProduct" msdata:parent="IProduct" msdata:child="IDetail_Return" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="IDetail_Return" msprop:Generator_ChildPropName="GetIDetail_ReturnRows" msprop:Generator_UserRelationName="FK_IDetail_Return_IProduct" msprop:Generator_RelationVarName="relationFK_IDetail_Return_IProduct" msprop:Generator_UserParentTable="IProduct" msprop:Generator_ParentPropName="IProductRow" />
      <msdata:Relationship name="FK_IDetail_Return_IReturn" msdata:parent="IReturn" msdata:child="IDetail_Return" msdata:parentkey="ReturnID" msdata:childkey="ReturnID" msprop:Generator_UserChildTable="IDetail_Return" msprop:Generator_ChildPropName="GetIDetail_ReturnRows" msprop:Generator_UserRelationName="FK_IDetail_Return_IReturn" msprop:Generator_RelationVarName="relationFK_IDetail_Return_IReturn" msprop:Generator_UserParentTable="IReturn" msprop:Generator_ParentPropName="IReturnRow" />
      <msdata:Relationship name="FK_IEmployee_IDepartment" msdata:parent="IDepartment" msdata:child="IEmployee" msdata:parentkey="DepartmentID" msdata:childkey="DepartmentID" msprop:Generator_UserChildTable="IEmployee" msprop:Generator_ChildPropName="GetIEmployeeRows" msprop:Generator_UserRelationName="FK_IEmployee_IDepartment" msprop:Generator_ParentPropName="IDepartmentRow" msprop:Generator_RelationVarName="relationFK_IEmployee_IDepartment" msprop:Generator_UserParentTable="IDepartment" />
      <msdata:Relationship name="FK_IInvoice_ICustomer" msdata:parent="ICustomer" msdata:child="IInvoice" msdata:parentkey="CustomerID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="IInvoice" msprop:Generator_ChildPropName="GetIInvoiceRows" msprop:Generator_UserRelationName="FK_IInvoice_ICustomer" msprop:Generator_ParentPropName="ICustomerRow" msprop:Generator_RelationVarName="relationFK_IInvoice_ICustomer" msprop:Generator_UserParentTable="ICustomer" />
      <msdata:Relationship name="FK_ILineItem_IInvoice" msdata:parent="IInvoice" msdata:child="ILineItem" msdata:parentkey="InvoceID" msdata:childkey="InvoceID" msprop:Generator_UserChildTable="ILineItem" msprop:Generator_ChildPropName="GetILineItemRows" msprop:Generator_UserRelationName="FK_ILineItem_IInvoice" msprop:Generator_ParentPropName="IInvoiceRow" msprop:Generator_RelationVarName="relationFK_ILineItem_IInvoice" msprop:Generator_UserParentTable="IInvoice" />
      <msdata:Relationship name="FK_ILineItem_IProduct" msdata:parent="IProduct" msdata:child="ILineItem" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ILineItem" msprop:Generator_ChildPropName="GetILineItemRows" msprop:Generator_UserRelationName="FK_ILineItem_IProduct" msprop:Generator_RelationVarName="relationFK_ILineItem_IProduct" msprop:Generator_UserParentTable="IProduct" msprop:Generator_ParentPropName="IProductRow" />
      <msdata:Relationship name="FK_IPaid_Receipt_Invoice_IInvoice" msdata:parent="IInvoice" msdata:child="IPaid_Receipt_Invoice" msdata:parentkey="InvoceID" msdata:childkey="InvoceID" msprop:Generator_UserChildTable="IPaid_Receipt_Invoice" msprop:Generator_ChildPropName="GetIPaid_Receipt_InvoiceRows" msprop:Generator_UserRelationName="FK_IPaid_Receipt_Invoice_IInvoice" msprop:Generator_ParentPropName="IInvoiceRow" msprop:Generator_RelationVarName="relationFK_IPaid_Receipt_Invoice_IInvoice" msprop:Generator_UserParentTable="IInvoice" />
      <msdata:Relationship name="FK_IPaid_Receipt_Invoice_IReceipt" msdata:parent="IReceipt" msdata:child="IPaid_Receipt_Invoice" msdata:parentkey="ReceiptID" msdata:childkey="ReceiptID" msprop:Generator_UserChildTable="IPaid_Receipt_Invoice" msprop:Generator_ChildPropName="GetIPaid_Receipt_InvoiceRows" msprop:Generator_UserRelationName="FK_IPaid_Receipt_Invoice_IReceipt" msprop:Generator_RelationVarName="relationFK_IPaid_Receipt_Invoice_IReceipt" msprop:Generator_UserParentTable="IReceipt" msprop:Generator_ParentPropName="IReceiptRow" />
      <msdata:Relationship name="FK_IPrice_return_ICategory" msdata:parent="ICategory" msdata:child="IPrice_return" msdata:parentkey="CategoryID" msdata:childkey="CategoryID" msprop:Generator_UserChildTable="IPrice_return" msprop:Generator_ChildPropName="GetIPrice_returnRows" msprop:Generator_UserRelationName="FK_IPrice_return_ICategory" msprop:Generator_ParentPropName="ICategoryRow" msprop:Generator_RelationVarName="relationFK_IPrice_return_ICategory" msprop:Generator_UserParentTable="ICategory" />
      <msdata:Relationship name="FK_IPrice_return_IReturn" msdata:parent="IReturn" msdata:child="IPrice_return" msdata:parentkey="ReturnID" msdata:childkey="ReturnID" msprop:Generator_UserChildTable="IPrice_return" msprop:Generator_ChildPropName="GetIPrice_returnRows" msprop:Generator_UserRelationName="FK_IPrice_return_IReturn" msprop:Generator_RelationVarName="relationFK_IPrice_return_IReturn" msprop:Generator_UserParentTable="IReturn" msprop:Generator_ParentPropName="IReturnRow" />
      <msdata:Relationship name="FK_IProduct_ICategory" msdata:parent="ICategory" msdata:child="IProduct" msdata:parentkey="CategoryID" msdata:childkey="CategoryID" msprop:Generator_UserChildTable="IProduct" msprop:Generator_ChildPropName="GetIProductRows" msprop:Generator_UserRelationName="FK_IProduct_ICategory" msprop:Generator_ParentPropName="ICategoryRow" msprop:Generator_RelationVarName="relationFK_IProduct_ICategory" msprop:Generator_UserParentTable="ICategory" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>